package cn.gson.crmdemo.model.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import com.alibaba.fastjson.JSONArray;
@Mapper
public interface OrderMapper {
	public JSONArray selctOrder();
	
	public JSONArray selctOrderdcl();
	
	public JSONArray selectOrderID(int a);
	
	public int selectMaxOrderID();
	
	public JSONArray selectQuotationWhereOrder(int Oid);
	
	public JSONArray selectMaxAddressId();
	
	public JSONArray selectSalesnities();
	
	public JSONArray selectAddressName();
	
	public JSONArray selectAddressID(int a);
	
	public JSONArray selectQuotation();
	
	public JSONArray selectQuotationwhereCustomer(int a);
	
	public void updateDstate(int dstate);
	
	public int selectMaxOutorderId();
	
	public JSONArray selectOutorderIdaddDetailed(int a);
	
	public void updateHouseCk(@Param("ck_number")int ck_number,@Param("cp_id")int cp_id );
	
	public int selectMaxDeliverId();
	
	public JSONArray selectDeliverIdaddDetailed(int a);
	
	public void updateDstateDeliver(int dstate);
	
	public void updateReturnState(int dstate);
	
	public int selectMaxReturnId();
	
	public JSONArray selectMaxReturnIdaddDetailed(int a);
	
	public JSONArray selectDstate(int dstate);
	
	public JSONArray mhselectCompany(String companyName);
	
	public void updateGoodsOk(int dstate);
}
